UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZzSwZXbW1FsXUrkoFvDfD81pxq1MhggJu5zhhKJmZU='
WHERE
key_id = '7fe26faf7d7db17fb45a14fc8c603a9d4d306bff7e663ce6309de0c3d3bb3690'
AND (
token = 'QZzSwZXbW1FsXUrkoFvDfD81pxq1MhggJu5zhhKJmZU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)