UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CAfA2b0WXyYPc/ifRCVTp+FUn9QZq46JbLGlrX3gUs='
WHERE
key_id = 'cd08d5c782b0c18240d7b54abd8f897316f2d0a16e2d79a4e894e5d6a1875fe5'
AND (
token = '/CAfA2b0WXyYPc/ifRCVTp+FUn9QZq46JbLGlrX3gUs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)