UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xXJzpmd1hI8WV/QKlYjPB0vRsfNDzTZU3gEnYHGjJkA='
WHERE
key_id = '89200e798d8e2e074011157a0e2b945b9e6cbd488ccd43fb93abc0b5965a345c'
AND (
token = 'xXJzpmd1hI8WV/QKlYjPB0vRsfNDzTZU3gEnYHGjJkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)