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