UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't2yVzwr+oHCr2idAkyn6IDFtVVJknhjsjOVfHludogI='
WHERE
key_id = 'd12e6f0c407159b5cd755e6fed1fe2c2f72b4ed9ca630739930bd9802c1d1197'
AND (
token = 't2yVzwr+oHCr2idAkyn6IDFtVVJknhjsjOVfHludogI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)