UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCnMk9Uv76/tX+TQ8/kARyhs0pISGlQrjMuQKC1/F58='
WHERE
key_id = '948e5ac7fb47225fb5692deb3511371ae25ba04ba1ff8495780407e6e3bbffb8'
AND (
token = 'hCnMk9Uv76/tX+TQ8/kARyhs0pISGlQrjMuQKC1/F58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)