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