UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+7hNXrHgrj2Jtm6isZ/n8GTQkUc/ab9/sP7QQvt7n8='
WHERE
key_id = '0fc1ca74a2989e051af461b3247079f0971b02c1580df852954102d59484c205'
AND (
token = 'W+7hNXrHgrj2Jtm6isZ/n8GTQkUc/ab9/sP7QQvt7n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)