UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X10HCD9Bz5rUEIIeyPbGfXKahswXR0y9TAZbV6HPidA='
WHERE
key_id = '9b26702bb6ea5683a31f38ccb907daddae0eb09838b838eca00a305e32930d04'
AND (
token = 'X10HCD9Bz5rUEIIeyPbGfXKahswXR0y9TAZbV6HPidA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)