UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S4R5V8xcO5OdkIurFcf1crat1As0pa8RRt57n0J8AH8='
WHERE
key_id = 'be78d3bd2239d0b59483a15022aaf532e8e52dcebc9ce2892db404dbfe581d1f'
AND (
token = 'S4R5V8xcO5OdkIurFcf1crat1As0pa8RRt57n0J8AH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)