UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ajg6XvI9qnLVyx0LKVNIwIePI+zVMnBTJDF1TUICIhs='
WHERE
key_id = 'bcaef16c7e9ebdff9549a6be5e01f9d6f8aea4db725d2eb504fa87a1bd68fe3c'
AND (
token = 'Ajg6XvI9qnLVyx0LKVNIwIePI+zVMnBTJDF1TUICIhs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)