UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '03Mr7pX/KQj0gkfQcOHtN5bWxdIMkuT6T+HVNCNov48='
WHERE
key_id = '9e6d8790b14081911bd86ecdbbffe0e48bdc34af31a66723848067cbeac303ae'
AND (
token = '03Mr7pX/KQj0gkfQcOHtN5bWxdIMkuT6T+HVNCNov48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)