UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z938+sfoqasQRpyRurWmtQmo4efon+Ys2dzGZbbjqy0='
WHERE
key_id = 'ebc69b7b42f33f506f82706678ade8594d6e87ce5b737414ba1b0752d00399c5'
AND (
token = 'Z938+sfoqasQRpyRurWmtQmo4efon+Ys2dzGZbbjqy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)