UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2zLGnBXajyzNOVVMkjuWriy7M9MW1MtsETseBk1ubCY='
WHERE
key_id = 'd5e40f5bb32796a1e3396726a2592d1a39f3be4a728e5d7c55002e41063ce7f1'
AND (
token = '2zLGnBXajyzNOVVMkjuWriy7M9MW1MtsETseBk1ubCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)