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