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