UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj6MncNGl0/vqqZW4SrImKNlB2v2iYHq9PGmeX83SKg='
WHERE
key_id = 'a9b77eed055759ec20b19d34718451d09fd776815df553800cd3a966c034b741'
AND (
token = 'zj6MncNGl0/vqqZW4SrImKNlB2v2iYHq9PGmeX83SKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)