UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KUyUxUhFsy0VdeMzWb7TA/UfpBlwfFjJsbejjRM4fw='
WHERE
key_id = '9405028190a303d8219d854d8318e6bc431b81e4492efe23bebcd4746437e070'
AND (
token = '4KUyUxUhFsy0VdeMzWb7TA/UfpBlwfFjJsbejjRM4fw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)