UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'accPNgOc94/KIxrWskCIf+wwuZcVyOPwuGgMkKPB8Vw='
WHERE
key_id = 'fc97d1fdc08acdae98d87110285c566fcb69373766bd1856bf99b49a16642a95'
AND (
token = 'accPNgOc94/KIxrWskCIf+wwuZcVyOPwuGgMkKPB8Vw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)