UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/3CPxpJwPpff58VFPDlpbqa5Jj3d+Ojbarj+vu0/OEE='
WHERE
key_id = '8e2d3c9b1ea791ed78bc5b77889cf4ae3477ef090df7c2a4f56fbd73e0cf5c7a'
AND (
token = '/3CPxpJwPpff58VFPDlpbqa5Jj3d+Ojbarj+vu0/OEE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)