UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XBCM4i9VmTKsY+PkvCJk/KaP4JAvbKzFXVIVFUBeyAw='
WHERE
key_id = 'adc4f0c1f8dd2b39d8e11a903de5f11ca8eb61d2fe972f4ef2e71838dd7f42c5'
AND (
token = 'XBCM4i9VmTKsY+PkvCJk/KaP4JAvbKzFXVIVFUBeyAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)