UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49WYf08TfnW1uKk25nltEMoQk1oDhTApQfT252nsRO4='
WHERE
key_id = '639bcc6cfa64e695c9888fe3363e2692836c41fb57dddf99845b4f44a3dcb8fb'
AND (
token = '49WYf08TfnW1uKk25nltEMoQk1oDhTApQfT252nsRO4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)