UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ot63zaeoM6tqr47iZvGiUXdBPwXzbLDvVZ6+FsGZejM='
WHERE
key_id = 'e263aef6bc8db225a499880cb1514509bdbced93ddb7569c0d8c94d0f9a0db5b'
AND (
token = 'ot63zaeoM6tqr47iZvGiUXdBPwXzbLDvVZ6+FsGZejM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)