UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nZHqD74UJhfnvmzOVMxPPaz3AKHE/isW/+Nxbq+VAfA='
WHERE
key_id = 'c6c5d660b85b923266b3a19c9b50c3405c2b9da1f945951e6ad3ef5e6c937bf7'
AND (
token = 'nZHqD74UJhfnvmzOVMxPPaz3AKHE/isW/+Nxbq+VAfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)