UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRRtsyuMzFPQkbJhwSOBgCPx+PB+8OCdBcuvNw+2NN4='
WHERE
key_id = 'a77c2f198e2e9e5a815d6ed1ef00d53f97f4e5909f157dada5bc7a243a31c7d4'
AND (
token = 'KRRtsyuMzFPQkbJhwSOBgCPx+PB+8OCdBcuvNw+2NN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)