UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0YOukwG6HKbzMLPhbHoOoWRpYYXWUw152xJLRNU3i0o='
WHERE
key_id = '9ccb50b6722072aecf7020a5e25d51c0eb15a4f4027a287c24d8517bdc2c22da'
AND (
token = '0YOukwG6HKbzMLPhbHoOoWRpYYXWUw152xJLRNU3i0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)