UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6f8Oc7gnQ192wnSYayEOF7+9g+SCscezGVnGTuLQ0+8='
WHERE
key_id = '9d1ba6a5b69d681947305c73a8a3e1708d30b664f9231bb49908ae84c7945683'
AND (
token = '6f8Oc7gnQ192wnSYayEOF7+9g+SCscezGVnGTuLQ0+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)