UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BOz8GH+5sOCZchaR6d3dlykHPPIHCt2AZuNMyDUUg9s='
WHERE
key_id = 'b92ad5de2296d9dd747b252a1114f0ef8c021e92170da7b5c1d3d817ef71cadc'
AND (
token = 'BOz8GH+5sOCZchaR6d3dlykHPPIHCt2AZuNMyDUUg9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)