UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Z5JJFhv6ksgrNQttNy3RGNvmtoqpQFsLIoBBwcs9b8='
WHERE
key_id = '9bcdf5a3ca3b811b17a1eb2a30e44202a109c5f478bafd7b1ff5244e116df7ce'
AND (
token = '+Z5JJFhv6ksgrNQttNy3RGNvmtoqpQFsLIoBBwcs9b8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)