UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47aDS73JJ3Axu3VKNtSFreuvxrPvtoarezK9HrwkE0w='
WHERE
key_id = 'aaf7dd78c1f2be3001123403fb9a66a449857f8ec783cd0ff282f3b33ae775c8'
AND (
token = '47aDS73JJ3Axu3VKNtSFreuvxrPvtoarezK9HrwkE0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)