UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50RjDqStm8rICHcb9EWV7uPjLVK5zBUr4sTsUashvM8='
WHERE
key_id = '4ec0407b5eb2b85c7533942a307649a29387c97c12b2a00a2fa3b5f326575ca5'
AND (
token = '50RjDqStm8rICHcb9EWV7uPjLVK5zBUr4sTsUashvM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)