UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jtCTmJBnxCsOTj2LF1NEM3RuZ3YGJ0wKmd+imUjVE2w='
WHERE
key_id = '23e190331f965b97abdeab89a2c7b5bdec6520faf04aa1d1f941b02d6492af39'
AND (
token = 'jtCTmJBnxCsOTj2LF1NEM3RuZ3YGJ0wKmd+imUjVE2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)