UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P6SjFQ58CVZNhwYx5mRit6m35Q9/kOIjzHSrdZ/iECo='
WHERE
key_id = 'b3b5939e53239ab76b2b951fd1bf35b53e6288f61fb57b1bce70db3503072f97'
AND (
token = 'P6SjFQ58CVZNhwYx5mRit6m35Q9/kOIjzHSrdZ/iECo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)