UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8MHFh1evKyBplprHxSTJfy3ylbuXYPZzVzJ/WLHbT8='
WHERE
key_id = 'c696b1f14d42bf681f5927beca17f47246db40d8d75a29bf1362c374b4f9a2e5'
AND (
token = '/8MHFh1evKyBplprHxSTJfy3ylbuXYPZzVzJ/WLHbT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)