UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P5CNk8zkP88AnDXSB/lKsEqpzoT0uUOtC1QU1DMiHZQ='
WHERE
key_id = 'dd9a1acfa14a3e6fa635efe0e49d32dff5a5d50f7423f90e7a89f7902d3b3676'
AND (
token = 'P5CNk8zkP88AnDXSB/lKsEqpzoT0uUOtC1QU1DMiHZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)